SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_GetSurveys]
	/*
	(
	@parameter1 int = 5,
	@parameter2 datatype OUTPUT
	)
	*/
AS
	/* SET NOCOUNT ON */
	SELECT TOP 5 id,topic,start_time FROM dbo.JOL_SurveyManagement_Theme 
--	WHERE start_time<=GETDATE() AND end_time>=GETDATE()
	Order by start_time DESC
	RETURN

GO
